package com.mfnote.db;

/**
 * 数据库DML实体类
 * 
 * @author ZHF
 * 
 */
public class DBInfo {

	public static final String DB_NAME = "MFNote.db"; // 数据库名称
	public static final int VERSION = 1; // 数据库版本

	public static class Table { // 此处之所以建内部类，为了统一管理建表工作

		// 表名
		public static final String TB_MAINRECORD_NAME = "mainRecord";
		public static final String TB_WRITE_NAME = "write";
		public static final String TB_PAINT_NAME = "paint";
		public static final String TB_HAND_NAME = "hand";
		public static final String TB_RECORD_NAME = "record";
		public static final String TB_NEWWRITEREMIND_NAME = "remind";

	/*********************** 创建表**********************************************************/
		public static final String CREATE_TB_MAINRECORD = "create table if not exists "
				+ TB_MAINRECORD_NAME
				+ "(_id Integer primary key,  writeCount long, paintCount long, handCount long, recordCount long);";

		public static final String CREATE_TB_WRITE = "create table if not exists "
				+ TB_WRITE_NAME
				+ "(_id Integer primary key, title TEXT, content TEXT, imagePath TEXT,videoPath TEXT, time TEXT, color TEXT,background int,lock int);";

		public static final String CREATE_TB_PAINT = "create table if not exists "
				+ TB_PAINT_NAME
				+ "(id Integer primary key, title TEXT, imagePath TEXT, time TEXT);";

		public static final String CREATE_TB_HAND = "create table if not exists "
				+ TB_HAND_NAME
				+ "(_id Integer primary key,title TEXT, imagePath TEXT,time TEXT,flag int);";

		public static final String CREATE_TB_RECORD = "create table if not exists "
				+ TB_RECORD_NAME
				+ "(_id Integer primary key, title TEXT, recordPath TEXT, time TEXT, recordLength int,size int);";
		
		public static final String CREATE_TB_NEWWRITEREMIND = "create table if not exists "
				+ TB_NEWWRITEREMIND_NAME
				+ "(_id Integer primary key, title TEXT, groupId int);";  //通过后面的ID分组：老师、学生、。。。

	/***************************** 删除表**********************************************/
		public static final String DROP_TB_MAINRECORD = "drop table "
				+ TB_MAINRECORD_NAME;
		public static final String DROP_TB_WRITE_NAME = "drop table "
				+ TB_WRITE_NAME;
		public static final String DROP_TB_PAINT_NAME = "drop table "
				+ TB_PAINT_NAME;
		public static final String DROP_TB_HAND_NAME = "drop table "
				+ TB_HAND_NAME;
		public static final String DROP_TB_RECORD_NAME = "drop table "
				+ TB_RECORD_NAME;
		public static final String DROP_TB_NEWWRITEREMIND_NAME = "drop table"
				+ TB_NEWWRITEREMIND_NAME;
	}
	
	/*************后期sql语句增加处。。。************/
	
	
	
}
